Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 734932 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 122.7 MiB |
| Average record size in memory | 175.0 B |
Variable types
| Numeric | 9 |
|---|---|
| DateTime | 1 |
| Categorical | 9 |
| Unsupported | 1 |
day_of_week is highly overall correlated with open | High correlation |
customers is highly overall correlated with sales | High correlation |
promo2_since_year is highly overall correlated with promo2 | High correlation |
sales is highly overall correlated with customers and 1 other fields | High correlation |
open is highly overall correlated with day_of_week and 1 other fields | High correlation |
store_type is highly overall correlated with assortment | High correlation |
assortment is highly overall correlated with store_type | High correlation |
promo2 is highly overall correlated with promo2_since_year | High correlation |
state_holiday is highly imbalanced (88.2%) | Imbalance |
promo_interval is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
customers has 124977 (17.0%) zeros | Zeros |
sales has 124979 (17.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-12 18:58:59.203622 |
|---|---|
| Analysis finished | 2023-06-12 18:59:43.698889 |
| Duration | 44.5 seconds |
| Software version | pandas-profiling v0.0.dev0 |
| Download configuration | config.json |
store
Real number (ℝ)
| Distinct | 1115 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 558.51995 |
| Minimum | 1 |
|---|---|
| Maximum | 1115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 281 |
| median | 558 |
| Q3 | 837 |
| 95-th percentile | 1060 |
| Maximum | 1115 |
| Range | 1114 |
| Interquartile range (IQR) | 556 |
Descriptive statistics
| Standard deviation | 321.87006 |
|---|---|
| Coefficient of variation (CV) | 0.57629107 |
| Kurtosis | -1.199737 |
| Mean | 558.51995 |
| Median Absolute Deviation (MAD) | 278 |
| Skewness | -0.0014385114 |
| Sum | 4.1047418 × 108 |
| Variance | 103600.34 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 885 | 727 | 0.1% |
| 116 | 720 | 0.1% |
| 381 | 719 | 0.1% |
| 881 | 717 | 0.1% |
| 102 | 716 | 0.1% |
| 544 | 715 | 0.1% |
| 757 | 713 | 0.1% |
| 246 | 712 | 0.1% |
| 511 | 711 | 0.1% |
| 847 | 711 | 0.1% |
| Other values (1105) | 727771 |
| Value | Count | Frequency (%) |
| 1 | 676 | |
| 2 | 681 | |
| 3 | 689 | |
| 4 | 683 | |
| 5 | 682 | |
| 6 | 685 | |
| 7 | 670 | |
| 8 | 675 | |
| 9 | 668 | |
| 10 | 680 |
| Value | Count | Frequency (%) |
| 1115 | 674 | |
| 1114 | 686 | |
| 1113 | 687 | |
| 1112 | 690 | |
| 1111 | 668 | |
| 1110 | 670 | |
| 1109 | 564 | |
| 1108 | 684 | |
| 1107 | 568 | |
| 1106 | 674 |
day_of_week
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9977495 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9977421 |
|---|---|
| Coefficient of variation (CV) | 0.4997167 |
| Kurtosis | -1.2470392 |
| Mean | 3.9977495 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0017088695 |
| Sum | 2938074 |
| Variance | 3.9909737 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 105361 | |
| 4 | 105338 | |
| 3 | 105268 | |
| 2 | 105114 | |
| 1 | 104757 | |
| 7 | 104564 | |
| 6 | 104530 |
| Value | Count | Frequency (%) |
| 1 | 104757 | |
| 2 | 105114 | |
| 3 | 105268 | |
| 4 | 105338 | |
| 5 | 105361 | |
| 6 | 104530 | |
| 7 | 104564 |
| Value | Count | Frequency (%) |
| 7 | 104564 | |
| 6 | 104530 | |
| 5 | 105361 | |
| 4 | 105338 | |
| 3 | 105268 | |
| 2 | 105114 | |
| 1 | 104757 |
date
Date
| Distinct | 942 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2015-07-31 00:00:00 |
customers
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 3962 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 632.96202 |
| Minimum | 0 |
|---|---|
| Maximum | 7388 |
| Zeros | 124977 |
| Zeros (%) | 17.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 404 |
| median | 609 |
| Q3 | 837 |
| 95-th percentile | 1361 |
| Maximum | 7388 |
| Range | 7388 |
| Interquartile range (IQR) | 433 |
Descriptive statistics
| Standard deviation | 464.21296 |
|---|---|
| Coefficient of variation (CV) | 0.7333978 |
| Kurtosis | 7.1147692 |
| Mean | 632.96202 |
| Median Absolute Deviation (MAD) | 216 |
| Skewness | 1.5982741 |
| Sum | 4.6518404 × 108 |
| Variance | 215493.67 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 124977 | 17.0% |
| 560 | 1796 | 0.2% |
| 576 | 1727 | 0.2% |
| 533 | 1699 | 0.2% |
| 555 | 1694 | 0.2% |
| 651 | 1692 | 0.2% |
| 566 | 1687 | 0.2% |
| 614 | 1684 | 0.2% |
| 603 | 1683 | 0.2% |
| 517 | 1670 | 0.2% |
| Other values (3952) | 594623 |
| Value | Count | Frequency (%) |
| 0 | 124977 | |
| 3 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 36 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 61 | 1 | < 0.1% |
| 64 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7388 | 1 | |
| 5494 | 1 | |
| 5387 | 1 | |
| 5297 | 1 | |
| 5192 | 1 | |
| 5152 | 1 | |
| 5112 | 1 | |
| 5106 | 1 | |
| 5090 | 1 | |
| 5069 | 1 |
open
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 734932 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 734932 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 609995 | |
| 0 | 124937 | 17.0% |
promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 734932 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 734932 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 454226 | |
| 1 | 280706 |
state_holiday
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 0 | |
|---|---|
| a | 14691 |
| b | 4844 |
| c | 2975 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 712422 | |
| a | 14691 | 2.0% |
| b | 4844 | 0.7% |
| c | 2975 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 712422 | |
| a | 14691 | 2.0% |
| b | 4844 | 0.7% |
| c | 2975 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 712422 | |
| a | 14691 | 2.0% |
| b | 4844 | 0.7% |
| c | 2975 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 712422 | |
| Lowercase Letter | 22510 | 3.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 14691 | |
| b | 4844 | 21.5% |
| c | 2975 | 13.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 712422 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 712422 | |
| Latin | 22510 | 3.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 14691 | |
| b | 4844 | 21.5% |
| c | 2975 | 13.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 712422 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 712422 | |
| a | 14691 | 2.0% |
| b | 4844 | 0.7% |
| c | 2975 | 0.4% |
school_holiday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 734932 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 734932 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 603648 | |
| 1 | 131284 | 17.9% |
store_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| a | |
|---|---|
| d | |
| c | |
| b | 11329 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | a |
|---|---|
| 2nd row | a |
| 3rd row | a |
| 4th row | a |
| 5th row | c |
Common Values
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 734932 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 734932 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 398944 | |
| d | 225963 | |
| c | 98696 | 13.4% |
| b | 11329 | 1.5% |
assortment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| a | |
|---|---|
| c | |
| b | 5967 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | c |
|---|---|
| 2nd row | c |
| 3rd row | c |
| 4th row | a |
| 5th row | a |
Common Values
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 734932 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 734932 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 388938 | |
| c | 340027 | |
| b | 5967 | 0.8% |
competition_distance
Real number (ℝ)
| Distinct | 655 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5928.7621 |
| Minimum | 20 |
|---|---|
| Maximum | 200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.2 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 130 |
| Q1 | 710 |
| median | 2330 |
| Q3 | 6900 |
| 95-th percentile | 20620 |
| Maximum | 200000 |
| Range | 199980 |
| Interquartile range (IQR) | 6190 |
Descriptive statistics
| Standard deviation | 12551.454 |
|---|---|
| Coefficient of variation (CV) | 2.1170447 |
| Kurtosis | 147.86516 |
| Mean | 5928.7621 |
| Median Absolute Deviation (MAD) | 1980 |
| Skewness | 10.248645 |
| Sum | 4.357237 × 109 |
| Variance | 1.5753901 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 250 | 8017 | 1.1% |
| 350 | 5433 | 0.7% |
| 50 | 5427 | 0.7% |
| 190 | 5396 | 0.7% |
| 1200 | 5308 | 0.7% |
| 90 | 4771 | 0.6% |
| 180 | 4759 | 0.6% |
| 330 | 4615 | 0.6% |
| 150 | 4537 | 0.6% |
| 2640 | 4108 | 0.6% |
| Other values (645) | 682561 |
| Value | Count | Frequency (%) |
| 20 | 675 | 0.1% |
| 30 | 2746 | |
| 40 | 3463 | |
| 50 | 5427 | |
| 60 | 2051 | 0.3% |
| 70 | 3276 | |
| 80 | 2044 | 0.3% |
| 90 | 4771 | |
| 100 | 3405 | |
| 110 | 3906 |
| Value | Count | Frequency (%) |
| 200000 | 1912 | |
| 75860 | 674 | 0.1% |
| 58260 | 679 | 0.1% |
| 48330 | 677 | 0.1% |
| 46590 | 677 | 0.1% |
| 45740 | 661 | 0.1% |
| 44320 | 695 | 0.1% |
| 40860 | 697 | 0.1% |
| 40540 | 662 | 0.1% |
| 38710 | 701 | 0.1% |
competition_open_since_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.7827976 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3105199 |
|---|---|
| Coefficient of variation (CV) | 0.48807588 |
| Kurtosis | -1.2326458 |
| Mean | 6.7827976 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.039781499 |
| Sum | 4984895 |
| Variance | 10.959542 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 96573 | |
| 4 | 85963 | |
| 11 | 74996 | |
| 3 | 69994 | |
| 7 | 65563 | |
| 12 | 56394 | |
| 6 | 55917 | |
| 10 | 54732 | |
| 5 | 52526 | |
| 2 | 48863 | |
| Other values (2) | 73411 |
| Value | Count | Frequency (%) |
| 1 | 32741 | 4.5% |
| 2 | 48863 | |
| 3 | 69994 | |
| 4 | 85963 | |
| 5 | 52526 | |
| 6 | 55917 | |
| 7 | 65563 | |
| 8 | 40670 | |
| 9 | 96573 | |
| 10 | 54732 |
| Value | Count | Frequency (%) |
| 12 | 56394 | |
| 11 | 74996 | |
| 10 | 54732 | |
| 9 | 96573 | |
| 8 | 40670 | |
| 7 | 65563 | |
| 6 | 55917 | |
| 5 | 52526 | |
| 4 | 85963 | |
| 3 | 69994 |
competition_open_since_year
Real number (ℝ)
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2010.3233 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.4 MiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 2002 |
| Q1 | 2008 |
| median | 2012 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 5.536153 |
|---|---|
| Coefficient of variation (CV) | 0.0027538621 |
| Kurtosis | 125.26688 |
| Mean | 2010.3233 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -7.3090883 |
| Sum | 1.4774509 × 109 |
| Variance | 30.64899 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 147998 | |
| 2014 | 132033 | |
| 2015 | 79378 | |
| 2012 | 53849 | 7.3% |
| 2005 | 40765 | 5.5% |
| 2010 | 37027 | 5.0% |
| 2009 | 35809 | 4.9% |
| 2011 | 35669 | 4.9% |
| 2008 | 35010 | 4.8% |
| 2007 | 31502 | 4.3% |
| Other values (13) | 105892 |
| Value | Count | Frequency (%) |
| 1900 | 562 | 0.1% |
| 1961 | 681 | 0.1% |
| 1990 | 3390 | 0.5% |
| 1994 | 1384 | 0.2% |
| 1995 | 1238 | 0.2% |
| 1998 | 674 | 0.1% |
| 1999 | 5275 | 0.7% |
| 2000 | 6659 | 0.9% |
| 2001 | 10728 | |
| 2002 | 17838 |
| Value | Count | Frequency (%) |
| 2015 | 79378 | |
| 2014 | 132033 | |
| 2013 | 147998 | |
| 2012 | 53849 | 7.3% |
| 2011 | 35669 | 4.9% |
| 2010 | 37027 | 5.0% |
| 2009 | 35809 | 4.9% |
| 2008 | 35010 | 4.8% |
| 2007 | 31502 | 4.3% |
| 2006 | 30966 | 4.2% |
promo2
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 734932 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 734932 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 368064 | |
| 0 | 366868 |
promo2_since_week
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.612393 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 12 |
| median | 22 |
| Q3 | 37 |
| 95-th percentile | 47 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 14.307916 |
|---|---|
| Coefficient of variation (CV) | 0.60594943 |
| Kurtosis | -1.1844802 |
| Mean | 23.612393 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.17935973 |
| Sum | 17353503 |
| Variance | 204.71646 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 61114 | 8.3% |
| 40 | 50652 | 6.9% |
| 10 | 36560 | 5.0% |
| 31 | 36167 | 4.9% |
| 5 | 34059 | 4.6% |
| 1 | 31226 | 4.2% |
| 13 | 29873 | 4.1% |
| 37 | 29102 | 4.0% |
| 22 | 28940 | 3.9% |
| 18 | 27986 | 3.8% |
| Other values (42) | 369253 |
| Value | Count | Frequency (%) |
| 1 | 31226 | |
| 2 | 8275 | 1.1% |
| 3 | 8221 | 1.1% |
| 4 | 8242 | 1.1% |
| 5 | 34059 | |
| 6 | 8955 | 1.2% |
| 7 | 8191 | 1.1% |
| 8 | 8303 | 1.1% |
| 9 | 17191 | |
| 10 | 36560 |
| Value | Count | Frequency (%) |
| 52 | 5319 | 0.7% |
| 51 | 5345 | 0.7% |
| 50 | 6041 | 0.8% |
| 49 | 5902 | 0.8% |
| 48 | 11417 | |
| 47 | 5399 | 0.7% |
| 46 | 5400 | 0.7% |
| 45 | 26597 | |
| 44 | 7265 | 1.0% |
| 43 | 5368 | 0.7% |
promo2_since_year
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.7932 |
| Minimum | 2009 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.4 MiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2012 |
| median | 2013 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6634744 |
|---|---|
| Coefficient of variation (CV) | 0.00082645073 |
| Kurtosis | -0.21233728 |
| Mean | 2012.7932 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.7841154 |
| Sum | 1.4792661 × 109 |
| Variance | 2.767147 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 223052 | |
| 2014 | 198092 | |
| 2015 | 89969 | |
| 2011 | 83174 | 11.3% |
| 2012 | 52739 | 7.2% |
| 2009 | 47220 | 6.4% |
| 2010 | 40686 | 5.5% |
| Value | Count | Frequency (%) |
| 2009 | 47220 | 6.4% |
| 2010 | 40686 | 5.5% |
| 2011 | 83174 | 11.3% |
| 2012 | 52739 | 7.2% |
| 2013 | 223052 | |
| 2014 | 198092 | |
| 2015 | 89969 |
| Value | Count | Frequency (%) |
| 2015 | 89969 | |
| 2014 | 198092 | |
| 2013 | 223052 | |
| 2012 | 52739 | 7.2% |
| 2011 | 83174 | 11.3% |
| 2010 | 40686 | 5.5% |
| 2009 | 47220 | 6.4% |
promo_interval
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
sales
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 20629 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5770.9286 |
| Minimum | 0 |
|---|---|
| Maximum | 41551 |
| Zeros | 124979 |
| Zeros (%) | 17.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3725 |
| median | 5743 |
| Q3 | 7857 |
| 95-th percentile | 12120 |
| Maximum | 41551 |
| Range | 41551 |
| Interquartile range (IQR) | 4132 |
Descriptive statistics
| Standard deviation | 3847.5133 |
|---|---|
| Coefficient of variation (CV) | 0.66670611 |
| Kurtosis | 1.7789504 |
| Mean | 5770.9286 |
| Median Absolute Deviation (MAD) | 2068 |
| Skewness | 0.63968359 |
| Sum | 4.2412401 × 109 |
| Variance | 14803359 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 124979 | 17.0% |
| 5674 | 157 | < 0.1% |
| 5931 | 147 | < 0.1% |
| 5449 | 145 | < 0.1% |
| 5489 | 145 | < 0.1% |
| 6615 | 144 | < 0.1% |
| 5041 | 142 | < 0.1% |
| 5989 | 141 | < 0.1% |
| 5558 | 140 | < 0.1% |
| 5096 | 139 | < 0.1% |
| Other values (20619) | 608653 |
| Value | Count | Frequency (%) |
| 0 | 124979 | |
| 46 | 1 | < 0.1% |
| 124 | 1 | < 0.1% |
| 286 | 1 | < 0.1% |
| 297 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 520 | 1 | < 0.1% |
| 530 | 1 | < 0.1% |
| 538 | 1 | < 0.1% |
| 541 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41551 | 1 | |
| 38367 | 1 | |
| 38037 | 1 | |
| 38025 | 1 | |
| 37403 | 1 | |
| 37376 | 1 | |
| 36227 | 1 | |
| 35909 | 1 | |
| 35702 | 1 | |
| 35154 | 1 |
month_map
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| Mar | |
|---|---|
| May | |
| Jan | |
| Jun | |
| Apr | |
| Other values (7) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0604138 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2249196 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jan |
|---|---|
| 2nd row | Fev |
| 3rd row | Jan |
| 4th row | Jun |
| 5th row | Apr |
Common Values
| Value | Count | Frequency (%) |
| Mar | 75250 | |
| May | 74942 | |
| Jan | 74892 | |
| Jun | 72526 | |
| Apr | 72500 | |
| Jul | 70862 | |
| Fev | 67641 | |
| Aug | 46025 | |
| Oct | 45789 | |
| Dec | 45676 | |
| Other values (2) | 88829 |
Length
| Value | Count | Frequency (%) |
| mar | 75250 | |
| may | 74942 | |
| jan | 74892 | |
| jun | 72526 | |
| apr | 72500 | |
| jul | 70862 | |
| fev | 67641 | |
| aug | 46025 | |
| oct | 45789 | |
| dec | 45676 | |
| Other values (2) | 88829 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 225084 | 10.0% |
| J | 218280 | 9.7% |
| u | 189413 | 8.4% |
| e | 157717 | 7.0% |
| M | 150192 | 6.7% |
| r | 147750 | 6.6% |
| n | 147418 | 6.6% |
| A | 118525 | 5.3% |
| p | 116900 | 5.2% |
| v | 112070 | 5.0% |
| Other values (11) | 665847 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1514264 | |
| Uppercase Letter | 734932 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 225084 | |
| u | 189413 | |
| e | 157717 | |
| r | 147750 | |
| n | 147418 | |
| p | 116900 | |
| v | 112070 | |
| c | 91465 | |
| t | 90189 | |
| y | 74942 | 4.9% |
| Other values (3) | 161316 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 218280 | |
| M | 150192 | |
| A | 118525 | |
| F | 67641 | 9.2% |
| O | 45789 | 6.2% |
| D | 45676 | 6.2% |
| N | 44429 | 6.0% |
| S | 44400 | 6.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2249196 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 225084 | 10.0% |
| J | 218280 | 9.7% |
| u | 189413 | 8.4% |
| e | 157717 | 7.0% |
| M | 150192 | 6.7% |
| r | 147750 | 6.6% |
| n | 147418 | 6.6% |
| A | 118525 | 5.3% |
| p | 116900 | 5.2% |
| v | 112070 | 5.0% |
| Other values (11) | 665847 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2249196 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 225084 | 10.0% |
| J | 218280 | 9.7% |
| u | 189413 | 8.4% |
| e | 157717 | 7.0% |
| M | 150192 | 6.7% |
| r | 147750 | 6.6% |
| n | 147418 | 6.6% |
| A | 118525 | 5.3% |
| p | 116900 | 5.2% |
| v | 112070 | 5.0% |
| Other values (11) | 665847 |
is_promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 734932 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 734932 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 734932 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 616567 | |
| 1 | 118365 | 16.1% |
| store | day_of_week | customers | competition_distance | competition_open_since_month | competition_open_since_year | promo2_since_week | promo2_since_year | sales | open | promo | state_holiday | school_holiday | store_type | assortment | promo2 | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| store | 1.000 | 0.000 | 0.021 | -0.046 | -0.033 | 0.004 | 0.005 | 0.008 | 0.000 | 0.006 | 0.000 | 0.000 | 0.002 | 0.095 | 0.111 | 0.072 | 0.000 | 0.035 |
| day_of_week | 0.000 | 1.000 | -0.432 | 0.001 | -0.002 | 0.000 | -0.003 | 0.001 | -0.451 | 0.875 | 0.496 | 0.120 | 0.264 | 0.000 | 0.000 | 0.000 | 0.031 | 0.011 |
| customers | 0.021 | -0.432 | 1.000 | -0.180 | 0.003 | 0.015 | 0.032 | 0.121 | 0.903 | 0.327 | 0.279 | 0.071 | 0.047 | 0.318 | 0.273 | 0.181 | 0.024 | 0.081 |
| competition_distance | -0.046 | 0.001 | -0.180 | 1.000 | -0.024 | 0.009 | -0.014 | 0.030 | -0.027 | 0.013 | 0.000 | 0.000 | 0.002 | 0.045 | 0.062 | 0.159 | 0.000 | 0.070 |
| competition_open_since_month | -0.033 | -0.002 | 0.003 | -0.024 | 1.000 | -0.233 | 0.108 | 0.017 | -0.002 | 0.024 | 0.013 | 0.061 | 0.132 | 0.068 | 0.058 | 0.132 | 0.326 | 0.084 |
| competition_open_since_year | 0.004 | 0.000 | 0.015 | 0.009 | -0.233 | 1.000 | 0.018 | 0.030 | 0.029 | 0.000 | 0.000 | 0.002 | 0.000 | 0.055 | 0.078 | 0.054 | 0.001 | 0.029 |
| promo2_since_week | 0.005 | -0.003 | 0.032 | -0.014 | 0.108 | 0.018 | 1.000 | -0.121 | 0.056 | 0.033 | 0.051 | 0.102 | 0.182 | 0.072 | 0.091 | 0.283 | 0.432 | 0.160 |
| promo2_since_year | 0.008 | 0.001 | 0.121 | 0.030 | 0.017 | 0.030 | -0.121 | 1.000 | 0.062 | 0.005 | 0.015 | 0.016 | 0.026 | 0.084 | 0.109 | 0.682 | 0.099 | 0.304 |
| sales | 0.000 | -0.451 | 0.903 | -0.027 | -0.002 | 0.029 | 0.056 | 0.062 | 1.000 | 0.705 | 0.453 | 0.155 | 0.083 | 0.107 | 0.081 | 0.104 | 0.044 | 0.051 |
| open | 0.006 | 0.875 | 0.327 | 0.013 | 0.024 | 0.000 | 0.033 | 0.005 | 0.705 | 1.000 | 0.295 | 0.379 | 0.087 | 0.051 | 0.039 | 0.008 | 0.074 | 0.000 |
| promo | 0.000 | 0.496 | 0.279 | 0.000 | 0.013 | 0.000 | 0.051 | 0.015 | 0.453 | 0.295 | 1.000 | 0.054 | 0.067 | 0.000 | 0.000 | 0.000 | 0.052 | 0.005 |
| state_holiday | 0.000 | 0.120 | 0.071 | 0.000 | 0.061 | 0.002 | 0.102 | 0.016 | 0.155 | 0.379 | 0.054 | 1.000 | 0.213 | 0.002 | 0.001 | 0.011 | 0.220 | 0.027 |
| school_holiday | 0.002 | 0.264 | 0.047 | 0.002 | 0.132 | 0.000 | 0.182 | 0.026 | 0.083 | 0.087 | 0.067 | 0.213 | 1.000 | 0.003 | 0.002 | 0.007 | 0.385 | 0.026 |
| store_type | 0.095 | 0.000 | 0.318 | 0.045 | 0.068 | 0.055 | 0.072 | 0.084 | 0.107 | 0.051 | 0.000 | 0.002 | 0.003 | 1.000 | 0.539 | 0.105 | 0.007 | 0.045 |
| assortment | 0.111 | 0.000 | 0.273 | 0.062 | 0.058 | 0.078 | 0.091 | 0.109 | 0.081 | 0.039 | 0.000 | 0.001 | 0.002 | 0.539 | 1.000 | 0.014 | 0.005 | 0.008 |
| promo2 | 0.072 | 0.000 | 0.181 | 0.159 | 0.132 | 0.054 | 0.283 | 0.682 | 0.104 | 0.008 | 0.000 | 0.011 | 0.007 | 0.105 | 0.014 | 1.000 | 0.029 | 0.437 |
| month_map | 0.000 | 0.031 | 0.024 | 0.000 | 0.326 | 0.001 | 0.432 | 0.099 | 0.044 | 0.074 | 0.052 | 0.220 | 0.385 | 0.007 | 0.005 | 0.029 | 1.000 | 0.274 |
| is_promo | 0.035 | 0.011 | 0.081 | 0.070 | 0.084 | 0.029 | 0.160 | 0.304 | 0.051 | 0.000 | 0.005 | 0.027 | 0.026 | 0.045 | 0.008 | 0.437 | 0.274 | 1.000 |
| store | day_of_week | date | customers | open | promo | state_holiday | school_holiday | store_type | assortment | competition_distance | competition_open_since_month | competition_open_since_year | promo2 | promo2_since_week | promo2_since_year | promo_interval | sales | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 582092 | 848 | 7 | 2014-01-26 | 0 | 0 | 0 | 0 | 0 | a | c | 370.000 | 7 | 2007 | 1 | 14 | 2011 | Jan,Apr,Jul,Oct | 0 | Jan | 1 |
| 184305 | 331 | 1 | 2015-02-16 | 803 | 1 | 1 | 0 | 0 | a | c | 670.000 | 2 | 2015 | 1 | 14 | 2015 | Jan,Apr,Jul,Oct | 7039 | Fev | 0 |
| 223725 | 726 | 1 | 2015-01-12 | 1437 | 1 | 1 | 0 | 0 | a | c | 40540.000 | 2 | 2002 | 0 | 3 | 2015 | 0 | 15611 | Jan | 0 |
| 60746 | 537 | 7 | 2015-06-07 | 0 | 0 | 0 | 0 | 0 | a | a | 600.000 | 5 | 2002 | 1 | 1 | 2012 | Jan,Apr,Jul,Oct | 0 | Jun | 0 |
| 485468 | 114 | 2 | 2014-04-22 | 550 | 1 | 0 | 0 | 1 | c | a | 4510.000 | 4 | 2014 | 1 | 48 | 2011 | Mar,Jun,Sept,Dec | 4260 | Apr | 0 |
| 209171 | 667 | 7 | 2015-01-25 | 0 | 0 | 0 | 0 | 0 | d | c | 2870.000 | 9 | 2012 | 0 | 4 | 2015 | 0 | 0 | Jan | 0 |
| 992815 | 136 | 2 | 2013-01-22 | 424 | 1 | 1 | 0 | 0 | a | c | 2200.000 | 12 | 2010 | 1 | 22 | 2012 | Feb,May,Aug,Nov | 5360 | Jan | 0 |
| 758907 | 378 | 2 | 2013-08-20 | 764 | 1 | 0 | 0 | 1 | a | c | 2140.000 | 8 | 2012 | 0 | 34 | 2013 | 0 | 4536 | Aug | 0 |
| 561223 | 49 | 4 | 2014-02-13 | 464 | 1 | 0 | 0 | 0 | d | c | 18010.000 | 9 | 2007 | 0 | 7 | 2014 | 0 | 5822 | Fev | 0 |
| 33999 | 550 | 3 | 2015-07-01 | 402 | 1 | 1 | 0 | 0 | d | c | 50.000 | 6 | 2015 | 0 | 27 | 2015 | 0 | 5605 | Jul | 0 |
| store | day_of_week | date | customers | open | promo | state_holiday | school_holiday | store_type | assortment | competition_distance | competition_open_since_month | competition_open_since_year | promo2 | promo2_since_week | promo2_since_year | promo_interval | sales | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 669466 | 137 | 5 | 2013-11-08 | 1088 | 1 | 1 | 0 | 0 | a | a | 1730.000 | 7 | 2015 | 1 | 40 | 2014 | Jan,Apr,Jul,Oct | 9252 | Nov | 0 |
| 995705 | 796 | 7 | 2013-01-20 | 0 | 0 | 0 | 0 | 0 | a | c | 7180.000 | 11 | 2012 | 0 | 3 | 2013 | 0 | 0 | Jan | 0 |
| 356367 | 369 | 1 | 2014-08-25 | 513 | 1 | 0 | 0 | 1 | d | c | 5870.000 | 4 | 2014 | 0 | 35 | 2014 | 0 | 5325 | Aug | 0 |
| 940624 | 350 | 7 | 2013-03-10 | 0 | 0 | 0 | 0 | 0 | d | a | 8880.000 | 3 | 2013 | 1 | 14 | 2011 | Jan,Apr,Jul,Oct | 0 | Mar | 0 |
| 68154 | 140 | 7 | 2015-05-31 | 0 | 0 | 0 | 0 | 0 | a | c | 1090.000 | 7 | 2010 | 1 | 1 | 2013 | Jan,Apr,Jul,Oct | 0 | May | 0 |
| 23715 | 301 | 5 | 2015-07-10 | 608 | 1 | 0 | 0 | 0 | a | c | 4510.000 | 3 | 2015 | 0 | 28 | 2015 | 0 | 5588 | Jul | 0 |
| 615742 | 1048 | 5 | 2013-12-27 | 562 | 1 | 0 | 0 | 1 | d | c | 1860.000 | 9 | 2012 | 1 | 40 | 2012 | Jan,Apr,Jul,Oct | 6416 | Dec | 0 |
| 783713 | 654 | 1 | 2013-07-29 | 950 | 1 | 1 | 0 | 1 | c | a | 6930.000 | 9 | 2006 | 0 | 31 | 2013 | 0 | 10257 | Jul | 0 |
| 982497 | 968 | 5 | 2013-02-01 | 955 | 1 | 0 | 0 | 0 | c | a | 1190.000 | 2 | 2013 | 0 | 5 | 2013 | 0 | 7285 | Fev | 0 |
| 533203 | 1019 | 2 | 2014-03-11 | 555 | 1 | 0 | 0 | 0 | d | c | 2740.000 | 7 | 2014 | 1 | 13 | 2010 | Jan,Apr,Jul,Oct | 6006 | Mar | 0 |